What is Simba?

Simba is a data connector software that serves as a critical link between various data sources and business intelligence tools or applications. It is renowned for its extensive deployment with more than one billion instances worldwide, particularly in real-time business intelligence and data analysis applications. As a testament to its reliability and trustworthiness, Simba is recognized by the creators of ODBC and its technology is embedded into leading operating systems and data platforms.

The software facilitates quick and comprehensive access to business intelligence by allowing users to connect any data source, whether SQL-enabled or NoSQL, to their preferred tools and applications. Simba achieves this through its construction of drivers that adhere to current standards, ensuring that they are reliable, scalable, and secure. Moreover, Simba's offerings include a software development kit (SDK) for ODBC/JDBC driver development, empowering users to develop custom drivers. These custom drivers streamline the connection process to data sources by reducing costs, complexity, risks, and time-to-market when compared to creating a driver from the ground up.

In addition to its core software capabilities, Simba provides a service that operates using port 1543. This service is an integral part of the data connectivity infrastructure that Simba offers. Furthermore, Simba Managed Services present a flexible and high-touch approach to data connectivity, shouldering the burden and simplifying the complexity associated with such integration processes for organizations.

The types of data associated with Simba are vast, including but not limited to Cost Object Types, Cost Centers, Internal Orders, and Work Breakdown Structure (WBS) elements. Simba data also encompasses various business-related information such as Budget Executive and Financial Officer data, Business Area BA Number data, Business Area Name data, and general Business Area data. These data types indicate the versatility and scope of Simba's application in a multitude of business intelligence contexts.

Simba Plugins for Excel

Simba plugins for Excel are currently not functioning. These plugins are intended to enhance Excel's capabilities by allowing users to connect to various data sources directly within Excel. However, due to their non-operational state, users are unable to utilize these plugins to access external data or engage in data analysis and integration tasks within Excel.

Common Use Cases

• S

  
  Backtesting investment strategies with historical returns data
• S

  
  Analyzing correlations and rolling returns of different assets
• S

  
  Customizing investment analysis with advanced user-defined calculations
• S

  
  Comparing final portfolio values using the Compare_Portfolios tab
• S

  
  Adjusting historical investment data for inflation effects

Frequently Asked Questions

What types of data sources can I connect to with Simba's data connectors?

Simba's data connectors allow users to access data from multiple sources, including relational and NoSQL databases, Big Data sources such as Hadoop, and SaaS and cloud sources like Salesforce, Google BigQuery, or Amazon Athena.

Can Simba's data connectors be used for real-time data connections?

Yes, Simba's data connectors allow users to connect to data in real time.

What should I do if I can connect to small tables but not large ones using the Simba BigQuery Driver in Excel?

If you can connect to small tables but not large ones, it may be an issue with the REST API or the job not being found. Check the configuration settings for any limitations on data size and ensure the REST API is properly configured. Additionally, verify that the job ID is correct and the job exists in BigQuery.

Are Simba's data connectors compatible with legacy and next-generation tools?

Yes, Simba's data connectors allow users to connect to legacy and next-generation tools and applications.

Can I develop custom drivers with Simba's technology?

Simba offers an SDK for developing custom ODBC/JDBC drivers for SQL-enabled or NoSQL data sources, reducing the cost, complexity, and time-to-market of driver development.