Optimized Bulk Loading of Data into Oracle

יום שישי, יוני 21, 2013

SQL Server 2008 and SQL Server 2008 R2 (Enterprise and Developer editions) support bulk loading Oracle data using Integration Services packages with the Microsoft Connector for Oracle by Attunity. For SQL Server 2005 and the non-Enterprise and non-Developer editions of SQL Server 2008 and 2008 R2, there are alternatives for achieving optimal performance when loading Oracle data. This paper discusses these alternatives.The Enterprise and Developer editions of SQL Server 2012 also support bulk loading Oracle data using Integration Services packages with the Microsoft Connector for Oracle by Attunity. To review the document, please download the Optimized Bulk Loading of Data into...
תגיות: , , , ,
אין תגובות

CDC for Oracle in SQL Server 2012

One of the new features introduced in SQL Server 2012 is the ability to use SQL Server CDC for tracking changes on an Oracle table. In the following post you will understand how to setup such a service for tracking changes on your Oracle tables.Configuring your Oracle serverBefore creating the service, you must ensure that the following configuration steps have been performed on your source Oracle database:1. The database is set to ARCHIVELOG and is OPEN2. The user that is going to connect to the Oracle database has DBA privileges on the database (since you will look up the...
תגיות: , , ,
אין תגובות

SSAS distinct count wrong results

יום שישי, יוני 14, 2013

I have added a connect item today.please vote for it: https://connect.microsoft.com/SQLServer/feedback/details/790216/ssas-distinct-count-wrong-results Issue:ssas distinct count results wrong number.While querying the table as follow: SELECT count (distinct USER_ID ) FROM Table I get this results -- 1033612while querying SSAS I get 257.sample data for USER_ID:42348-3648-1368306010878-D41D8CD98F00B204E9800998ECF8427E42348-3648-1368074987484-B26463A0EE1A5F27718A14533D020E6042348-3648-1368011144064-65DD703A82FFA13A98305295317C86AD42348-3648-1368049679418-D41D8CD98F00B204E9800998ECF8427EI have also tried to convert this Varchar(100) into checksum()sample data -235875173535581043287814888-1894147417still getting same results.the measure is located in stand alone measure group. and configured with default settings.Solution: No Solution so far.
אין תגובות

"GeoFlow" for Excel 2013

יום שישי, יוני 7, 2013

 Project codename “GeoFlow” Preview for Excel 2013 allows you to plot geographic and temporal data visually, analyze that data in 3D, and create interactive tours to share with others. This preview gives you an early look into the new features that provide 3D data visualization for Excel and a powerful method for people to look at information in new ways, enabling discoveries in data that might never be seen in traditional 2D tables and charts.download it from here->
תגיות: , ,
תגובה אחת

Cumulative update package 4 for SQL Server 2012 SP1

יום ראשון, יוני 2, 2013

 This post describes cumulative update package 4 for Microsoft SQL Server 2012 Service Pack 1 (SP1). This update contains hotfixes for issues that were fixed after the release of SQL Server 2012 SP1. Note The build number of the cumulative update package is 11.0.3368.0.download here:
תגיות: , ,
אין תגובות

מפגש BI # 43

יום ראשון, מאי 26, 2013

שלום לכולם, ברצוננו להזמין אתכם למפגש קהילת ה – BI. המפגש הקרוב יתקיים ב - 29.5 במשרדי מיקרוסופט רעננה, אולם דקל. מצורף לו"ז  לקראת המפגש.   לו"ז  ל Bi User Group Meeting #43(29.5.2013) להרשמה: http://biug43.eventbrite.com/#   17:30    התכנסות 18:00     Hadoop and BI: a match made in heaven?             Hadoop is the stellar Big Data software framework these days. In the session we will provide context to the rise and rise of this platform, explore various vendors' Hadoop offerings, specifically relating to the DWH and BI ecosystem, and try to understand how relevant Hadoop really is for the BI community. 19:30       הפסקה           19:45    שאלות ותשובות 20:30      סיום   המרצה: יניב מור, מנכ"ל חברת XPLENTY, עוסק בתחום ה – DATA  וה – BI  כ –...
תגיות: ,
אין תגובות

Whats New in SSIS 2012 (SP1)–מה חדש ב

יום שני, ינואר 28, 2013

גרסת SQL 2012 חושפת בפנינו יכולות חדשות אשר מחזקות את מעמדה בשוק בסיסי הנתונים ככלל והbi בפרט. לקראת השתתפותי במספר כנסים בשנה הקרובה במערב אירופה וצפון אמריקה, אני שמח לשתף אתכם בתובנות שהועלו עד כה ב SolidBI.com .   במאמר זה, אתייחס ל integration services בגרסת sql2012 sp1. למידע נוסף, הגדרות ארכיטקטורה, שיפורי ביצועים ו -best practices , הנכם מוזמנים ליצור קשר ב noya@solidbi.com  או  alberto@solidbi.com או דרך האתר שלנו ב http://www.solidbi.com   אז מה חדש בגרסת ssis 2012?   הפצת נתונים deployment  ניהול ופתרון בעיות באמצעות ממשק חדש  שיפורי פיתוח  מנגנון לשיפור איכות הנתונים וטיובם.  גישה לדוגמאות...
תגובה אחת

Microsoft® SQL Server® 2012 PowerPivot for Microsoft® Excel® 2010

יום שני, נובמבר 12, 2012

Microsoft PowerPivot for Microsoft Excel 2010 provides ground-breaking technology, such as fast manipulation of large data sets (often millions of rows), streamlined integration of data, and the ability to effortlessly share your analysis through Microsoft SharePoint 2010.Microsoft PowerPivot for Microsoft Excel 2010 is a data analysis tool that delivers unmatched computational power directly within the software users already know and love — Microsoft Excel. You can transform mass quantities of data with incredible speed into meaningful information to get the answers you need in seconds. You can effortlessly share your findings with others. You can: Process large data...
תגיות: , , ,
תגובה אחת

Microsoft® SQL Server® 2012 SP1 Data Mining Add-ins for Microsoft® Office®

Microsoft SQL Server 2012 SP1 Data Mining Add-ins for Microsoft Office helps you take advantage of SQL Server predictive analytics in Office Excel and Office Visio. The download includes the following components: Table Analysis Tools for Excel: This add-in provides easy-to-use tasks that leverage SQL Server 2012 data mining models within Excel using either your spreadsheet data or external data accessible through your SQL Server 2012 Analysis Services instance. Data Mining Client for Excel: By using this add-in, you can create, test, explore, and manage data mining models within Excel using either your spreadsheet data or external...
תגיות: , , ,
תגובה אחת